package com.mapper;

import com.pojo.Vip;
import com.pojo.Vipaccount;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface VipMapper {
//    查询所有vip
    List<Vip> vipFindAll();
    Vipaccount vipaccountFindByVid(Integer vid);

//    搜索
    List<Vip> vipFindLike(@Param("vid") Integer vid,@Param("vname") String vname,@Param("grade") String grade);

    //会员注册
    int vipInsert(Vip vip);
    int vipaccountInsert(Vipaccount vipaccount);

//    会员编辑
    int vipupdate(Vip vip);

//    会员删除
    int vipDelete(Integer vid);
    int vipaccountDelete(Integer vid);

    List<Vip> vipSelectVid(@Param("vid") Integer vid);
    List<Vip> vipSelectPhone(@Param("vid") String vid);

    int vipUpdintegral(@Param("vid") Integer vid,@Param("integral") Integer integral,@Param("grade") String grade);
}
